<!doctype html>
<html>
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width">
        <meta name="restype" content="documentation">
        <meta name="product" content="kendo-ui">
        <meta name="subproduct" content="spreadsheet">
        <title>List of Formulas and Functions | Kendo UI Spreadsheet</title>
        <link rel="shortcut icon" href="/favicon.ico"/>
        <meta name="description" content="A list of the formulas and functions available in the Kendo UI Spreadsheet widget.">
        <link href="//fonts.googleapis.com/css?family=Roboto:400,500,700,900" rel="stylesheet">
        <link href='https://fonts.googleapis.com/css?family=Roboto+Mono:400,500,700' rel='stylesheet' type='text/css'>
        <!-- <link href="https://kendo.cdn.telerik.com/2017.3.1026/styles/kendo.common.min.css" rel="stylesheet" /> -->
        <link rel="stylesheet" href="http://oygy5legq.bkt.clouddn.com/kendo.common.min.css">
        <link rel="stylesheet" href="/assets/styles.css?cb=8338967476da1c756a6defe19c1f9984">
        <link rel="stylesheet" href="/assets/icon-font.css?cb=25d8b9593057297c278fcd6d7d263c8e">
        <link rel="stylesheet" href="/assets/theme.css?cb=d82da02940126146560da1ae3bb0bf64">
        
        <!-- <script src="https://code.jquery.com/jquery-1.10.2.js"></script> -->
        <script src="https://cdn.bootcss.com/jquery/1.10.2/jquery.min.js"></script>
        <!-- <script src="https://kendo.cdn.telerik.com/2017.3.1026/js/kendo.web.min.js"></script> -->
        <script src="http://oygy5legq.bkt.clouddn.com/kendo.web.min.js"></script>
        <!-- <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.6.0/codemirror.min.css">
        <script src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.6.0/codemirror.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.6.0/mode/javascript/javascript.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.6.0/mode/css/css.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.6.0/mode/xml/xml.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.6.0/mode/htmlmixed/htmlmixed.min.js"></script> -->
        <script src="/assets/prettify.js?cb=9671553084e1962263b152af1f563c3c"></script>
        <script src="/assets/app.js?cb=c577f29da14c3752a8c4ba001dde39e5"></script>
        
        

        <!--[if lt IE 9]>
        <script>
        document.createElement('header');
        document.createElement('nav');
        document.createElement('section');
        document.createElement('article');
        document.createElement('aside');
        document.createElement('footer');
        document.createElement('hgroup');
        </script>
        <![endif]-->
    </head>
    <body>
        <!-- Google Tag Manager -->
        <!-- <noscript>
            <iframe src="//www.googletagmanager.com/ns.html?id=GTM-6X92" height="0" width="0" style="display: none; visibility: hidden"></iframe>
        </noscript>
        <script>(function(w, d, s, l, i) { w[l] = w[l] || []; w[l].push({ 'gtm.start': new Date().getTime(), event: 'gtm.js' }); var f = d.getElementsByTagName(s)[0], j = d.createElement(s), dl = l != 'dataLayer' ? '&l=' + l : ''; j.async = true; j.src = '//www.googletagmanager.com/gtm.js?id=' + i + dl; f.parentNode.insertBefore(j, f); })(window, document, 'script', 'dataLayer', 'GTM-6X92');</script> -->
        <!-- End Google Tag Manager -->
        <aside class="TK-Hat">
    <figure class="TK-Hat-Brand">
        <a href="https://www.progress.com" class="TK-PRGS-Logo">
            <svg xmlns="http://www.w3.org/2000/svg" width="94" height="40" viewBox="0 0 512 120">
                <path fill="#5ce500" d="M95.52 29.33v51a3.93 3.93 0 0 1-1.78 3.08l-1.67 1-12.72 7.35-8.59 5-1.78 1V42.6L21.23 15 43.91 1.93 46 .74a3.94 3.94 0 0 1 3.56 0L81 18.9l14.51 8.38v2.05zM58.36 48.72l-9.79-5.66-22.91-13.23a4 4 0 0 0-3.56 0L1.77 41.57 0 42.6l34.49 19.91v39.83l20.3-11.73 1.79-1a3.94 3.94 0 0 0 1.78-3.08V48.72zM0 82.43l23.86 13.78V68.63z"></path>
                <path fill="#4b4e52" d="M148.09 27.28h-26v70.48h11.55V70.1h14.57c15.77 0 24.45-7.7 24.45-21.69 0-6.35-2.4-21.12-24.55-21.12m12.78 21.31c0 7.95-4.12 11.19-14.24 11.19h-13v-22.1h14.57c8.56 0 12.71 3.57 12.71 10.91M207 46.41l.87.42-2 10.42-1.35-.42a11.32 11.32 0 0 0-3.34-.51c-10.79 0-11.67 8.59-11.67 19v22.44h-10.64V46h10v6.24c2.73-4.2 6-6.37 10.37-6.9a14.55 14.55 0 0 1 7.76 1.07M233.29 45c-8.42 0-15.16 3.2-19.5 9.27-4.56 6.37-5.23 13.85-5.23 17.74 0 16.36 9.7 26.92 24.73 26.92 18.26 0 24.73-14.71 24.73-27.3 0-7.25-2.15-13.82-6-18.51-4.41-5.31-10.87-8.12-18.7-8.12m0 44.38c-8.37 0-13.57-6.66-13.57-17.37s5.2-17.55 13.57-17.55S247 61.23 247 71.78c0 10.83-5.24 17.56-13.66 17.56m114.55-42.93l.87.42-2 10.42-1.35-.42a11.26 11.26 0 0 0-3.33-.51c-10.78 0-11.66 8.59-11.66 19v22.44h-10.66V46h10v6.24c2.73-4.2 6-6.37 10.37-6.9a14.54 14.54 0 0 1 7.73 1.06m38.4 34.76l-.2.57c-2.23 6.36-7.57 7.7-11.65 7.7-8.09 0-13.3-5.37-13.81-14.09h36.59l.13-1a31.26 31.26 0 0 0 .12-4.12v-.93C396.93 54.78 387.48 45 374 45c-7.9 0-14.37 3.1-18.73 9a30.85 30.85 0 0 0-5.54 18c0 16 9.95 26.74 24.74 26.74 11.45 0 19.33-5.82 22.2-16.38l.33-1.2h-10.7zM361 66.05c.9-7.17 5.81-11.73 12.79-11.73 5.33 0 11.64 3.1 12.52 11.73H361zm-60.7-15.71c-3.45-3.58-8.06-5.39-13.76-5.39-15.69 0-22.83 13.81-22.83 26.63 0 13.16 7.06 26.44 22.83 26.44a18.33 18.33 0 0 0 13.35-5.42c0 2.28-.1 4.45-.16 5.38-.58 8.54-4.68 12.51-12.91 12.51-4.47 0-9.61-1.59-10.6-6l-.22-1h-10.54l.17 1.41c1.1 9.12 9.11 14.79 20.9 14.79 10.34 0 17.7-3.9 21.28-11.26 1.73-3.55 2.6-8.72 2.6-15.37V46h-10.13v4.34zm-13.11 38.15c-3.74 0-12.43-1.69-12.43-17.37 0-10.3 4.87-16.7 12.71-16.7 6.06 0 12.52 4.39 12.52 16.7 0 10.87-4.79 17.37-12.81 17.37m159.67-6.31c0 8.23-6.83 16.53-22.09 16.53-13.5 0-21.53-5.85-22.61-16.45l-.15-1.1h10.52l.21.84c1.29 6.38 7.37 7.72 12.24 7.72 5.34 0 11-1.72 11-6.54 0-2.44-1.59-4.18-4.73-5.16-1.86-.55-4.15-1.2-6.56-1.87-4.16-1.16-8.47-2.38-11.12-3.29-6.56-2.35-10.33-6.93-10.33-12.56 0-10.43 10.16-15.11 20.22-15.11 13.46 0 20.42 5.07 21.3 15.49l.09 1.07H434.5l-.14-.82c-1-6-7-6.9-10.48-6.9-3 0-10 .53-10 5.5 0 2.25 1.93 3.91 5.89 5.06 1.18.33 2.94.78 5 1.31 4.22 1.09 9.48 2.46 12.13 3.37 6.59 2.32 9.93 6.67 9.93 13m49.39 0c0 8.23-6.83 16.53-22.09 16.53-13.5 0-21.53-5.85-22.61-16.45l-.11-1.09H462l.12.74c1.29 6.38 7.37 7.72 12.24 7.72 5.34 0 11-1.72 11-6.54 0-2.44-1.59-4.18-4.72-5.16-1.86-.55-4.15-1.2-6.57-1.87-4.16-1.16-8.46-2.38-11.11-3.29-6.57-2.35-10.33-6.93-10.33-12.56 0-10.43 10.16-15.11 20.22-15.11 13.46 0 20.42 5.07 21.29 15.49l.09 1.07H483.9l-.14-.82c-1-6-7-6.9-10.48-6.9-3 0-9.95.53-9.95 5.5 0 2.25 1.93 3.91 5.89 5.06 1.18.33 2.94.78 5 1.31 4.22 1.09 9.48 2.46 12.13 3.37 6.58 2.32 9.93 6.67 9.93 13m8.43-30.78a7.37 7.37 0 1 1 7.29-7.37 7.23 7.23 0 0 1-7.29 7.37m0-13.49a6.12 6.12 0 1 0 6 6.12 5.91 5.91 0 0 0-6-6.12m-.85 7.49v2.46h-2.17v-7.74h3.62a2.58 2.58 0 0 1 2.86 2.7 2.26 2.26 0 0 1-1.49 2.34l1.77 2.7H506l-1.49-2.46h-.68zm1.21-3.49h-1.21v1.73h1.21a.86.86 0 0 0 1-.85.88.88 0 0 0-1-.89"></path>
            </svg>
        </a>
    </figure>
</aside>
<header id="page-header">
    <div class="toggle-nav"><span class="k-icon k-i-menu"></span></div>


    <div id="logo-bar">
        <a href="/introduction">
            <img alt="Kendo UI logo" class="logo" src="/images/kendo-ui.svg">
        </a>
    </div>

    
    <span class="show-search">
        <span class="k-icon k-i-search"></span>
    </span>
    
    <div class="nav-buttons">
        <a href="http://demos.telerik.com/kendo-ui/" class="btn demos-btn">Demos</a>
        <a href="http://www.telerik.com/kendo-ui" class="btn about-btn">About</a>
        <a href="http://www.telerik.com/purchase/kendo-ui" class="btn pricing-btn">Pricing</a>
        <a href="http://www.telerik.com/download/kendo-ui" class="btn btn-primary">Try now</a>
    </div>
</header>
        <div id="page-inner-content">
    <div id="page-nav">
        <div id="page-tree"></div>
        <script>
        $("#page-tree").kendoTreeView({
            dataSource: {
                transport: {
                    read: {
                        url: "/default.json",
                        dataType: "json"
                    }
                },
                schema: {
                    model: {
                        id: "path",
                        children: "items",
                        hasChildren: "items"
                    }
                }
            },
            messages: {
                loading: " "
            },
            select: preventParentSelection,
            template: navigationTemplate("/"),
            dataBound: expandNavigation("controls/data-management/spreadsheet/end-user/list-of-formulas.html")
        });
        </script>
    </div>

    <a id="page-edit-link" href="https://github.com/telerik/kendo-ui-core/edit/master/docs//controls/data-management/spreadsheet/end-user/list-of-formulas.md"><span class="k-icon k-i-pencil"></span> Edit this page</a>
    

    <div id="page-article">
        <article>
            
             <h1 id="list-of-formulas-and-functions"><a href="#list-of-formulas-and-functions">List of Formulas and Functions</a></h1>

<p>The following table provides a list of the formulas and functions the Spreadsheet supports.</p>

<table>
<thead>
<tr>
<th align="left">Formulas and functions</th>
<th align="left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td align="left">ABS</td>
<td align="left">Returns the absolute (nonnegative) value of a number</td>
</tr>
<tr>
<td align="left">ACOS</td>
<td align="left">Returns the principal value of the arccosine of a number. The angle is returned in radians.</td>
</tr>
<tr>
<td align="left">ACOSH</td>
<td align="left">Returns the principal value of the inverse hyperbolic cosine of a number</td>
</tr>
<tr>
<td align="left">ACOT</td>
<td align="left">Returns the principal value of the arccotangent of a number. The angle is returned in radians.</td>
</tr>
<tr>
<td align="left">ACOTH</td>
<td align="left">Returns the hyperbolic arccotangent of a number</td>
</tr>
<tr>
<td align="left">ADDRESS</td>
<td align="left">Returns a cell address (reference) as a text</td>
</tr>
<tr>
<td align="left">AGGREGATE</td>
<td align="left">Returns an aggregate of a list or database</td>
</tr>
<tr>
<td align="left">ARABIC</td>
<td align="left">Converts Roman numbers to Arabic as numbers</td>
</tr>
<tr>
<td align="left">AREAS</td>
<td align="left">Returns the number of areas in a reference</td>
</tr>
<tr>
<td align="left">ASIN</td>
<td align="left">Returns the principal value of the arcsine of a number. The angle is returned in radians.</td>
</tr>
<tr>
<td align="left">ASINH</td>
<td align="left">Returns the principal value of the inverse hyperbolic sine of a number</td>
</tr>
<tr>
<td align="left">ATAN</td>
<td align="left">Returns the principal value of the arctangent of a number. The angle is returned in radians.</td>
</tr>
<tr>
<td align="left">ATAN2</td>
<td align="left">Returns the principal value of the arctangent from x- and y- coordinates in radians</td>
</tr>
<tr>
<td align="left">ATANH</td>
<td align="left">Returns the principal value of the inverse hyperbolic tangent of a number</td>
</tr>
<tr>
<td align="left">AVEDEV</td>
<td align="left">Calculates the average of the absolute deviations of listed values</td>
</tr>
<tr>
<td align="left">AVERAGE</td>
<td align="left">Returns the average of a set of numbers</td>
</tr>
<tr>
<td align="left">AVERAGEA</td>
<td align="left">Returns the average of values, including numbers, text, and logical values</td>
</tr>
<tr>
<td align="left">AVERAGEIF</td>
<td align="left">Returns the average of all cells in a range based on a given criteria</td>
</tr>
<tr>
<td align="left">AVERAGEIFS</td>
<td align="left">Returns the average of all cells in a range based on multiple criteria</td>
</tr>
<tr>
<td align="left">BASE</td>
<td align="left">Converts a number into a text representation with the given base</td>
</tr>
<tr>
<td align="left">BETA.DIST</td>
<td align="left">Returns the beta cumulative distribution function</td>
</tr>
<tr>
<td align="left">BETA.INV</td>
<td align="left">Returns the inverse of the cumulative distribution function for a specified beta distribution</td>
</tr>
<tr>
<td align="left">BETADIST</td>
<td align="left">Returns the value of the probability density function or the cumulative distribution function for the beta distribution</td>
</tr>
<tr>
<td align="left">BINOM.DIST</td>
<td align="left">Returns the individual term binomial distribution probability</td>
</tr>
<tr>
<td align="left">BINOM.DIST.RANGE</td>
<td align="left">Returns the probability of a trial result using a binomial distribution</td>
</tr>
<tr>
<td align="left">BINOM.INV</td>
<td align="left">Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value</td>
</tr>
<tr>
<td align="left">BINOMDIST</td>
<td align="left">Returns the binomial distribution probability</td>
</tr>
<tr>
<td align="left">CEILING</td>
<td align="left">Rounds a number to the nearest integer or to the nearest multiple of significance</td>
</tr>
<tr>
<td align="left">CEILING.MATH</td>
<td align="left">Rounds a number up, to the nearest integer or to the nearest multiple of significance</td>
</tr>
<tr>
<td align="left">CEILING.PRECISE</td>
<td align="left">Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.</td>
</tr>
<tr>
<td align="left">CHAR</td>
<td align="left">Return character represented by a given number</td>
</tr>
<tr>
<td align="left">CHISQ.DIST</td>
<td align="left">Returns the cumulative beta probability density function</td>
</tr>
<tr>
<td align="left">CHISQ.DIST.RT</td>
<td align="left">Returns the one-tailed probability of the chi-squared distribution</td>
</tr>
<tr>
<td align="left">CHISQ.INV</td>
<td align="left">Returns the cumulative beta probability density function</td>
</tr>
<tr>
<td align="left">CHISQ.INV.RT</td>
<td align="left">Returns the inverse of the one-tailed probability of the chi-squared distribution</td>
</tr>
<tr>
<td align="left">CHISQ.TEST</td>
<td align="left">Returns the test for independence</td>
</tr>
<tr>
<td align="left">CHOOSE</td>
<td align="left">Uses an index to return a value from a list of values</td>
</tr>
<tr>
<td align="left">CLEAN</td>
<td align="left">Removes all nonprintable characters from a text</td>
</tr>
<tr>
<td align="left">CODE</td>
<td align="left">Return a numeric value corresponding to the first character in a text string</td>
</tr>
<tr>
<td align="left">COLUMN</td>
<td align="left">Returns the column number(s) of a reference</td>
</tr>
<tr>
<td align="left">COLUMNS</td>
<td align="left">Returns the number of columns in a given range</td>
</tr>
<tr>
<td align="left">COMBIN</td>
<td align="left">Returns the number of combinations for a given number of objects</td>
</tr>
<tr>
<td align="left">COMBINA</td>
<td align="left">Returns the number of combinations with repetitions for a given number of objects</td>
</tr>
<tr>
<td align="left">CONCATENATE</td>
<td align="left">Joins a number of text strings into one text string</td>
</tr>
<tr>
<td align="left">CONFIDENCE.NORM</td>
<td align="left">Returns the confidence interval for a population mean</td>
</tr>
<tr>
<td align="left">CONFIDENCE.T</td>
<td align="left">Returns the confidence interval for a population mean, using a Student's t distribution</td>
</tr>
<tr>
<td align="left">COS</td>
<td align="left">Returns the cosine of a number. The angle is returned in radians.</td>
</tr>
<tr>
<td align="left">COSH</td>
<td align="left">Returns the hyperbolic cosine of a number</td>
</tr>
<tr>
<td align="left">COT</td>
<td align="left">Returns the cotangent of an angle, specified in radians</td>
</tr>
<tr>
<td align="left">COTH</td>
<td align="left">Returns the hyperbolic cotangent of a number</td>
</tr>
<tr>
<td align="left">COUNT</td>
<td align="left">Counts the number of numbers in a list of arguments</td>
</tr>
<tr>
<td align="left">COUNTA</td>
<td align="left">Counts the number of values in a  list of arguments</td>
</tr>
<tr>
<td align="left">COUNTBLANK</td>
<td align="left">Counts the number of blank cells in a range</td>
</tr>
<tr>
<td align="left">COUNTIF</td>
<td align="left">Counts the number of cells in a range that meet a criteria</td>
</tr>
<tr>
<td align="left">COUNTIFS</td>
<td align="left">Counts the number of cells in a range that meet multiple criteria</td>
</tr>
<tr>
<td align="left">COVAR</td>
<td align="left">Calculates the covariance between two cell ranges</td>
</tr>
<tr>
<td align="left">COVARIANCE.P</td>
<td align="left">Returns covariance, the average of the products of paired deviations</td>
</tr>
<tr>
<td align="left">COVARIANCE.S</td>
<td align="left">Returns the sample covariance, the average of the products deviations for each data point pair in two data sets</td>
</tr>
<tr>
<td align="left">CRITBINOM</td>
<td align="left">Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value</td>
</tr>
<tr>
<td align="left">CSC</td>
<td align="left">Returns the cosecant of an angle, specified in radians</td>
</tr>
<tr>
<td align="left">CSCH</td>
<td align="left">Returns the hyperbolic cosecant of an angle, specified in radians</td>
</tr>
<tr>
<td align="left">DATE</td>
<td align="left">Returns a date value constructed from a year, month, and day values</td>
</tr>
<tr>
<td align="left">DATEVALUE</td>
<td align="left">Returns the date converting it in the form of text to a serial number</td>
</tr>
<tr>
<td align="left">DAY</td>
<td align="left">Returns the day by converting it from a serial number</td>
</tr>
<tr>
<td align="left">DAYS</td>
<td align="left">Returns the number of days between two dates</td>
</tr>
<tr>
<td align="left">DAYS360</td>
<td align="left">Returns the number of days between two dates using the 360-day year</td>
</tr>
<tr>
<td align="left">DECIMAL</td>
<td align="left">Converts a text representation of a number in a given base into a decimal number</td>
</tr>
<tr>
<td align="left">DEGREES</td>
<td align="left">Converts radians to degrees</td>
</tr>
<tr>
<td align="left">DOLLAR</td>
<td align="left">Converts a number to text, using the <code>$</code> currency format</td>
</tr>
<tr>
<td align="left">EDATE</td>
<td align="left">Returns the serial number of the date that is the indicated number of months before or after the start date</td>
</tr>
<tr>
<td align="left">EOMONTH</td>
<td align="left">Returns the serial number of the last day of the month before or after a specified number of months</td>
</tr>
<tr>
<td align="left">ERF</td>
<td align="left">Returns the error function</td>
</tr>
<tr>
<td align="left">ERFC</td>
<td align="left">Returns the complementary error function</td>
</tr>
<tr>
<td align="left">EVEN</td>
<td align="left">Rounds a number up to the nearest even integer</td>
</tr>
<tr>
<td align="left">EXACT</td>
<td align="left">Reports if two text values are equal using a case-sensitive comparison</td>
</tr>
<tr>
<td align="left">EXP</td>
<td align="left">Returns <code>e</code> raised to the power of a given number</td>
</tr>
<tr>
<td align="left">EXPON.DIST</td>
<td align="left">Returns the exponential distribution</td>
</tr>
<tr>
<td align="left">F.DIST</td>
<td align="left">Returns the <code>F</code> probability distribution</td>
</tr>
<tr>
<td align="left">F.DIST.RT</td>
<td align="left">Returns the <code>F</code> probability distribution</td>
</tr>
<tr>
<td align="left">F.INV</td>
<td align="left">Returns the inverse of the <code>F</code> probability distribution</td>
</tr>
<tr>
<td align="left">F.INV.RT</td>
<td align="left">Returns the inverse of the <code>F</code> probability distribution</td>
</tr>
<tr>
<td align="left">F.TEST</td>
<td align="left">Returns the result of an <code>F</code>-test</td>
</tr>
<tr>
<td align="left">FACT</td>
<td align="left">Return factorial of a number</td>
</tr>
<tr>
<td align="left">FACTDOUBLE</td>
<td align="left">Returns the double factorial of a number</td>
</tr>
<tr>
<td align="left">FALSE</td>
<td align="left">Returns logical value <code>False</code>
</td>
</tr>
<tr>
<td align="left">FIND</td>
<td align="left">Returns the starting position of a given text</td>
</tr>
<tr>
<td align="left">FISHER</td>
<td align="left">Returns the <code>Fisher</code> transformation</td>
</tr>
<tr>
<td align="left">FISHERINV</td>
<td align="left">Returns the inverse of the <code>Fisher</code> transformation</td>
</tr>
<tr>
<td align="left">FIXED</td>
<td align="left">Rounds the number to a specified number of decimals and formats the result as a text</td>
</tr>
<tr>
<td align="left">FLOOR</td>
<td align="left">Rounds a number down to the nearest multiple of the second parameter</td>
</tr>
<tr>
<td align="left">FLOOR.MATH</td>
<td align="left">Rounds a number down, to the nearest integer or to the nearest multiple of significance</td>
</tr>
<tr>
<td align="left">FLOOR.PRECISE</td>
<td align="left">Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.</td>
</tr>
<tr>
<td align="left">FORECAST</td>
<td align="left">Assumes a future value based on existing x- and y- values</td>
</tr>
<tr>
<td align="left">FORMULATEXT</td>
<td align="left">Returns the formula at the given reference as text</td>
</tr>
<tr>
<td align="left">FREQUENCY</td>
<td align="left">Returns a frequency distribution as a vertical array</td>
</tr>
<tr>
<td align="left">GAMMA</td>
<td align="left">Return <code>Gamma</code> function value</td>
</tr>
<tr>
<td align="left">GAMMA.DIST</td>
<td align="left">Returns the <code>Gamma</code> distribution</td>
</tr>
<tr>
<td align="left">GAMMA.INV</td>
<td align="left">Returns the inverse of the <code>Gamma</code> cumulative distribution</td>
</tr>
<tr>
<td align="left">GAMMALN</td>
<td align="left">Returns the natural logarithm of the <code>Gamma</code> function</td>
</tr>
<tr>
<td align="left">GAUSS</td>
<td align="left">Returns 0.5 less than the standard normal cumulative distribution</td>
</tr>
<tr>
<td align="left">GCD</td>
<td align="left">Returns the greatest common divisor (GCD)</td>
</tr>
<tr>
<td align="left">GEOMEAN</td>
<td align="left">Returns the geometric mean of a sequence</td>
</tr>
<tr>
<td align="left">HARMEAN</td>
<td align="left">Returns the harmonic mean of a sequence</td>
</tr>
<tr>
<td align="left">HLOOKUP</td>
<td align="left">Looks for a matching value in the first row of a given table, and returns the value of the indicated row</td>
</tr>
<tr>
<td align="left">HOUR</td>
<td align="left">Converts a serial number to an hour</td>
</tr>
<tr>
<td align="left">HYPERLINK</td>
<td align="left">Creates a hyperlink involving an evaluated expression</td>
</tr>
<tr>
<td align="left">IF</td>
<td align="left">Returns one of two values, depending on a condition</td>
</tr>
<tr>
<td align="left">IFERROR</td>
<td align="left">Returns a specified value if a formula evaluates to an error; otherwise, returns the result of the formula</td>
</tr>
<tr>
<td align="left">INDEX</td>
<td align="left">Returns a value or a reference to a value from within a table or range</td>
</tr>
<tr>
<td align="left">INDIRECT</td>
<td align="left">Returns a reference indicated by a text value</td>
</tr>
<tr>
<td align="left">INT</td>
<td align="left">Rounds a number down to the nearest integer</td>
</tr>
<tr>
<td align="left">INTERCEPT</td>
<td align="left">Returns the intercept of the linear regression line for the given data</td>
</tr>
<tr>
<td align="left">ISBLANK</td>
<td align="left">Returns <code>True</code> if the referenced cell is blank; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISERR</td>
<td align="left">Returns <code>True</code> if the value is any error except <code>#N/A</code>; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISERROR</td>
<td align="left">Returns <code>True</code> if the value is any error; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISEVEN</td>
<td align="left">Returns <code>True</code> if the value is even; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISLOGICAL</td>
<td align="left">Returns <code>True</code> if the value is logical; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISNA</td>
<td align="left">Returns <code>True</code> if the value is the <code>#N/A</code> error; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISNONTEXT</td>
<td align="left">Returns <code>True</code> if the value is not text; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISNUMBER</td>
<td align="left">Returns <code>True</code> if the value is a number; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISO.CEILING</td>
<td align="left">Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance</td>
</tr>
<tr>
<td align="left">ISODD</td>
<td align="left">Returns <code>True</code> if the value is odd; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISOWEEKNUM</td>
<td align="left">Returns the ISO week number of the year for a given date</td>
</tr>
<tr>
<td align="left">ISREF</td>
<td align="left">Returns <code>True</code> if the value is a reference; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">ISTEXT</td>
<td align="left">Returns <code>True</code> if the value is text; else returns <code>False</code>
</td>
</tr>
<tr>
<td align="left">KURT</td>
<td align="left">Returns the kurtosis (“peakedness”) of a data set</td>
</tr>
<tr>
<td align="left">LARGE</td>
<td align="left">Finds the nth largest value in a list</td>
</tr>
<tr>
<td align="left">LCM</td>
<td align="left">Returns the least common multiple</td>
</tr>
<tr>
<td align="left">LEFT</td>
<td align="left">Returns a selected number of text characters from the left</td>
</tr>
<tr>
<td align="left">LEN</td>
<td align="left">Returns the number of characters from a given text</td>
</tr>
<tr>
<td align="left">LINEST</td>
<td align="left">Returns the parameters of a (simple or multiple) linear regression equation for the given data and, optionally, statistics on this regression</td>
</tr>
<tr>
<td align="left">LN</td>
<td align="left">Returns the natural logarithm of a number</td>
</tr>
<tr>
<td align="left">LOG</td>
<td align="left">Returns the logarithm of a number to a specified base</td>
</tr>
<tr>
<td align="left">LOG10</td>
<td align="left">Returns the base-10 logarithm of a number</td>
</tr>
<tr>
<td align="left">LOGEST</td>
<td align="left">Returns the parameters of an exponential regression equation for the given data obtained by linearizing this intrinsically linear response function and returns, optionally, statistics on this regression</td>
</tr>
<tr>
<td align="left">LOGNORM.DIST</td>
<td align="left">Returns the cumulative lognormal distribution</td>
</tr>
<tr>
<td align="left">LOGNORM.INV</td>
<td align="left">Returns the inverse of the lognormal cumulative distribution</td>
</tr>
<tr>
<td align="left">LOWER</td>
<td align="left">Converts text to lowercase</td>
</tr>
<tr>
<td align="left">MATCH</td>
<td align="left">Finds an item in a range of cells, and returns its relative position (starting from 1)</td>
</tr>
<tr>
<td align="left">MAX</td>
<td align="left">Returns the maximum value in a set of numbers</td>
</tr>
<tr>
<td align="left">MDETERM</td>
<td align="left">Returns the determinant of a matrix</td>
</tr>
<tr>
<td align="left">MEDIAN</td>
<td align="left">Returns the median (middle) value in a list of numbers</td>
</tr>
<tr>
<td align="left">MID</td>
<td align="left">Returns a specific number of characters from a text string, starting at a specified position</td>
</tr>
<tr>
<td align="left">MIN</td>
<td align="left">Returns the minimum value in a set of numbers</td>
</tr>
<tr>
<td align="left">MINUTE</td>
<td align="left">Converts a serial number into a minute</td>
</tr>
<tr>
<td align="left">MINVERSE</td>
<td align="left">Returns the inverse of a matrix</td>
</tr>
<tr>
<td align="left">MMULT</td>
<td align="left">Returns the matrix output of two arrays</td>
</tr>
<tr>
<td align="left">MOD</td>
<td align="left">Returns the remainder when one number is divided by another number</td>
</tr>
<tr>
<td align="left">MODE.MULT</td>
<td align="left">Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data</td>
</tr>
<tr>
<td align="left">MODE.SNGL</td>
<td align="left">Returns the most common value in a data set</td>
</tr>
<tr>
<td align="left">MONTH</td>
<td align="left">Converts a serial number to a month</td>
</tr>
<tr>
<td align="left">MROUND</td>
<td align="left">Rounds the number to the desired multiple</td>
</tr>
<tr>
<td align="left">MULTINOMIAL</td>
<td align="left">Returns the multinomial for a given set of values</td>
</tr>
<tr>
<td align="left">MUNIT</td>
<td align="left">Creates a unit matrix of a specified dimension</td>
</tr>
<tr>
<td align="left">N</td>
<td align="left">Returns the number of a value</td>
</tr>
<tr>
<td align="left">NA</td>
<td align="left">Returns the error value <code>#N/A</code>
</td>
</tr>
<tr>
<td align="left">NEGBINOM.DIST</td>
<td align="left">Returns the negative binomial distribution</td>
</tr>
<tr>
<td align="left">NEGBINOMDIST</td>
<td align="left">Returns the negative binomial distribution</td>
</tr>
<tr>
<td align="left">NETWORKDAYS</td>
<td align="left">Returns the number of whole workdays between two dates</td>
</tr>
<tr>
<td align="left">NORM.DIST</td>
<td align="left">Returns the normal cumulative distribution</td>
</tr>
<tr>
<td align="left">NORM.INV</td>
<td align="left">Returns the inverse of the normal cumulative distribution</td>
</tr>
<tr>
<td align="left">NORM.S.DIST</td>
<td align="left">Returns the standard normal cumulative distribution</td>
</tr>
<tr>
<td align="left">NORM.S.INV</td>
<td align="left">Returns the inverse of the standard normal cumulative distribution</td>
</tr>
<tr>
<td align="left">NOT</td>
<td align="left">Reverses the logic of its argument</td>
</tr>
<tr>
<td align="left">NOW</td>
<td align="left">Returns the serial number of the current date and time</td>
</tr>
<tr>
<td align="left">ODD</td>
<td align="left">Rounds a number up to the nearest odd integer, where "up" means "away from 0"</td>
</tr>
<tr>
<td align="left">OFFSET</td>
<td align="left">Modifies the position and dimension of a reference</td>
</tr>
<tr>
<td align="left">PEARSON</td>
<td align="left">Returns the <code>Pearson</code> correlation coefficient of two data sets</td>
</tr>
<tr>
<td align="left">PERCENTILE</td>
<td align="left">Calculates the x-th sample percentile of values in a range</td>
</tr>
<tr>
<td align="left">PERCENTILE.EXC</td>
<td align="left">Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive</td>
</tr>
<tr>
<td align="left">PERCENTILE.INC</td>
<td align="left">Returns the k-th percentile of values in a range</td>
</tr>
<tr>
<td align="left">PERCENTRANK</td>
<td align="left">Returns the percentage rank of a value in a sample</td>
</tr>
<tr>
<td align="left">PERCENTRANK.EXC</td>
<td align="left">Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set</td>
</tr>
<tr>
<td align="left">PERCENTRANK.INC</td>
<td align="left">Returns the percentage rank of a value in a data set</td>
</tr>
<tr>
<td align="left">PHI</td>
<td align="left">Returns the value of the density function for a standard normal distribution</td>
</tr>
<tr>
<td align="left">PI</td>
<td align="left">Returns the approximate value of pi</td>
</tr>
<tr>
<td align="left">POISSON.DIST</td>
<td align="left">Returns the <code>Poisson</code> distribution</td>
</tr>
<tr>
<td align="left">POWER</td>
<td align="left">Returns the result of a number raised to the power of another number</td>
</tr>
<tr>
<td align="left">PROB</td>
<td align="left">Returns the probability that values in a range are between two limits</td>
</tr>
<tr>
<td align="left">PRODUCT</td>
<td align="left">Multiplies the set of numbers, including all numbers inside ranges</td>
</tr>
<tr>
<td align="left">PROPER</td>
<td align="left">Capitalizes the first letter in each word of a text value</td>
</tr>
<tr>
<td align="left">QUARTILE</td>
<td align="left">Returns the quartile of a data set</td>
</tr>
<tr>
<td align="left">QUARTILE.EXC</td>
<td align="left">Returns the quartile of the data set, based on percentile values from 0..1, exclusive</td>
</tr>
<tr>
<td align="left">QUARTILE.INC</td>
<td align="left">Returns the quartile of a data set</td>
</tr>
<tr>
<td align="left">QUOTIENT</td>
<td align="left">Returns the integer portion of a division</td>
</tr>
<tr>
<td align="left">RADIANS</td>
<td align="left">Converts degrees to radians</td>
</tr>
<tr>
<td align="left">RAND</td>
<td align="left">Returns a random number between 0 (inclusive) and 1 (exclusive)</td>
</tr>
<tr>
<td align="left">RANDBETWEEN</td>
<td align="left">Returns a random number between specified values</td>
</tr>
<tr>
<td align="left">RANK</td>
<td align="left">Returns the rank of a number in a list of numbers</td>
</tr>
<tr>
<td align="left">RANK.AVG</td>
<td align="left">Returns the rank of a number in a list of numbers</td>
</tr>
<tr>
<td align="left">RANK.EQ</td>
<td align="left">Returns the rank of a number in a list of numbers</td>
</tr>
<tr>
<td align="left">REPLACE</td>
<td align="left">Replaces characters within text</td>
</tr>
<tr>
<td align="left">REPT</td>
<td align="left">Repeats text a specified number of times</td>
</tr>
<tr>
<td align="left">RIGHT</td>
<td align="left">Returns the rightmost characters from a text value</td>
</tr>
<tr>
<td align="left">ROMAN</td>
<td align="left">Converts Arabic numbers to Roman as text</td>
</tr>
<tr>
<td align="left">ROUNDDOWN</td>
<td align="left">Rounds a number down, towards zero, to the number of digits specified by <code>digits</code>
</td>
</tr>
<tr>
<td align="left">ROUNDUP</td>
<td align="left">Rounds a number up, away from 0 (zero), to the number of digits specified by <code>digits</code>
</td>
</tr>
<tr>
<td align="left">ROW</td>
<td align="left">Returns the row number(s) of a reference</td>
</tr>
<tr>
<td align="left">ROWS</td>
<td align="left">Returns the number of rows in a reference</td>
</tr>
<tr>
<td align="left">RSQ</td>
<td align="left">Returns the square of the <code>Pearson</code> product moment correlation coefficient</td>
</tr>
<tr>
<td align="left">SEARCH</td>
<td align="left">Finds a text value within another text value (not case-sensitive)</td>
</tr>
<tr>
<td align="left">SEC</td>
<td align="left">Returns the secant of an angle specified in radians</td>
</tr>
<tr>
<td align="left">SECH</td>
<td align="left">Returns the hyperbolic secant of a given angle specified in radians</td>
</tr>
<tr>
<td align="left">SECOND</td>
<td align="left">Converts a serial number to a second. This function presumes that leap seconds never exist.</td>
</tr>
<tr>
<td align="left">SERIESSUM</td>
<td align="left">Returns the sum of a power series based on the formula</td>
</tr>
<tr>
<td align="left">SIGN</td>
<td align="left">Returns the sign of a number</td>
</tr>
<tr>
<td align="left">SIN</td>
<td align="left">Returns the sine of an angle specified in radians</td>
</tr>
<tr>
<td align="left">SINH</td>
<td align="left">Returns the hyperbolic sine of a number</td>
</tr>
<tr>
<td align="left">SLOPE</td>
<td align="left">Calculates the slope of the linear regression line</td>
</tr>
<tr>
<td align="left">SMALL</td>
<td align="left">Finds the n-th smallest value in a data set</td>
</tr>
<tr>
<td align="left">SQRT</td>
<td align="left">Returns a positive square root of a number</td>
</tr>
<tr>
<td align="left">SQRTPI</td>
<td align="left">Returns the square root of a number multiplied by pi</td>
</tr>
<tr>
<td align="left">STDEV.P</td>
<td align="left">Calculates the standard deviation based on the entire population</td>
</tr>
<tr>
<td align="left">STDEV.S</td>
<td align="left">Estimates the standard deviation based on a sample</td>
</tr>
<tr>
<td align="left">STEYX</td>
<td align="left">Returns the standard error of the predicted y-value for each x in the regression</td>
</tr>
<tr>
<td align="left">SUBSTITUTE</td>
<td align="left">Substitutes new text for old text string</td>
</tr>
<tr>
<td align="left">SUBTOTAL</td>
<td align="left">Evaluates a function on a range</td>
</tr>
<tr>
<td align="left">SUM</td>
<td align="left">Sums (adds) the set of numbers, including all numbers in a range</td>
</tr>
<tr>
<td align="left">SUMIF</td>
<td align="left">Sums the values of cells in a range that meet a criteria</td>
</tr>
<tr>
<td align="left">SUMIFS</td>
<td align="left">Sums the values of cells in a range that meet multiple criteria</td>
</tr>
<tr>
<td align="left">SUMPRODUCT</td>
<td align="left">Returns the sum of the products of corresponding array elements</td>
</tr>
<tr>
<td align="left">SUMSQ</td>
<td align="left">Sums (adds) the set of squares of numbers, including all numbers in a range</td>
</tr>
<tr>
<td align="left">SUMX2MY2</td>
<td align="left">Returns the sum of the difference between the squares of corresponding values in two arrays</td>
</tr>
<tr>
<td align="left">SUMX2PY2</td>
<td align="left">Returns the sum of squares of corresponding values in two arrays</td>
</tr>
<tr>
<td align="left">SUMXMY2</td>
<td align="left">Returns the sum of squares of corresponding values in two arrays</td>
</tr>
<tr>
<td align="left">T</td>
<td align="left">Converts its arguments to text; else returns a 0-length text value</td>
</tr>
<tr>
<td align="left">T.DIST</td>
<td align="left">Returns the Percentage Points (probability) for the Student t-distribution</td>
</tr>
<tr>
<td align="left">T.DIST.2T</td>
<td align="left">Returns the Percentage Points (probability) for the Student t-distribution</td>
</tr>
<tr>
<td align="left">T.DIST.RT</td>
<td align="left">Returns the Student's t-distribution</td>
</tr>
<tr>
<td align="left">T.INV</td>
<td align="left">Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom</td>
</tr>
<tr>
<td align="left">T.INV.2T</td>
<td align="left">Returns the inverse of the Student's t-distribution</td>
</tr>
<tr>
<td align="left">T.TEST</td>
<td align="left">Returns the probability associated with a Student's t-test</td>
</tr>
<tr>
<td align="left">TAN</td>
<td align="left">Returns the tangent of a number in radians</td>
</tr>
<tr>
<td align="left">TANH</td>
<td align="left">Returns the hyperbolic tangent of a number</td>
</tr>
<tr>
<td align="left">TEXT</td>
<td align="left">Formats a number and converts it to text</td>
</tr>
<tr>
<td align="left">TIME</td>
<td align="left">Constructs a time value from hours, minutes, and seconds</td>
</tr>
<tr>
<td align="left">TIMEVALUE</td>
<td align="left">Returns the serial number of a particular time</td>
</tr>
<tr>
<td align="left">TODAY</td>
<td align="left">Returns the serial number of today's date</td>
</tr>
<tr>
<td align="left">TRANSPOSE</td>
<td align="left">Returns the transpose of an array</td>
</tr>
<tr>
<td align="left">TRIM</td>
<td align="left">Removes spaces from text; replaces all internal multiple spaces with a single space</td>
</tr>
<tr>
<td align="left">TRIMMEAN</td>
<td align="left">Returns the mean of the interior of a data set, ignoring a proportion of high and low values</td>
</tr>
<tr>
<td align="left">TRUE</td>
<td align="left">Returns the logical value <code>True</code>
</td>
</tr>
<tr>
<td align="left">UNICHAR</td>
<td align="left">Returns the character represented by the given numeric value according to the <a href="http://unicode.org/standard/standard.html">Unicode Standard</a>
</td>
</tr>
<tr>
<td align="left">UNICODE</td>
<td align="left">Returns the <a href="http://unicode.org/standard/standard.html">Unicode</a> code point that corresponds to the first character of a text value</td>
</tr>
<tr>
<td align="left">UPPER</td>
<td align="left">Converts text to uppercase</td>
</tr>
<tr>
<td align="left">VALUE</td>
<td align="left">Converts a text argument to a number</td>
</tr>
<tr>
<td align="left">VAR.P</td>
<td align="left">Calculates variance based on the entire population</td>
</tr>
<tr>
<td align="left">VAR.S</td>
<td align="left">Estimates variance based on a sample</td>
</tr>
<tr>
<td align="left">VLOOKUP</td>
<td align="left">Looks for a matching value in a table or a range by row</td>
</tr>
<tr>
<td align="left">WEEKDAY</td>
<td align="left">Converts a serial number to a day of the week</td>
</tr>
<tr>
<td align="left">WEEKNUM</td>
<td align="left">Determines the week number of the year for a given date</td>
</tr>
<tr>
<td align="left">WORKDAY</td>
<td align="left">Returns the date serial number which is a specified number of work days before or after an input date</td>
</tr>
<tr>
<td align="left">YEAR</td>
<td align="left">Converts a serial number to a year</td>
</tr>
<tr>
<td align="left">YEARFRAC</td>
<td align="left">Extracts the number of years (including fractional part) between two dates</td>
</tr>
</tbody>
</table>

<p>For more information on how to create formulas and what their syntax is, see the list of <a href="https://support.office.com/en-GB/article/Excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb?CorrelationId=343eb30b-8175-4479-be19-1310dd12334f">Excel functions</a>.</p>

<h2 id="array-formulas"><a href="#array-formulas">Array Formulas</a></h2>

<p>Similar to Excel, the Kendo UI Spreadsheet supports <a href="https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7?ui=en-US&amp;rs=en-US&amp;ad=US">array formulas</a> which return a matrix of values. You have to enter them in the same way as in Excel—by pre-selecting the target range and pressing <code>Ctrl</code>+<code>Shift</code>+<code>Enter</code> to save the formula.</p>

<h2 id="see-also"><a href="#see-also">See Also</a></h2>

<p>Other articles on Kendo UI Spreadsheet:</p>

<ul>
<li><a href="/controls/data-management/spreadsheet/end-user/list-of-shortcuts">List of Keyboard Shortcuts</a></li>
<li><a href="/controls/data-management/spreadsheet/end-user/user-guide">User Guide</a></li>
</ul> 
        </article>
    </div>
    <div id="feedback-container">
  <div id="feedback-section">
    <script src="/assets/feedback.js?cb=e99a3802c754fe2425831d58312c7c8b"></script>
    <span id="popupNotification"></span>
    <div id="feedback-menu-container">
      <div id="helpful-buttons-container">
        <span class="side-title">Is this article helpful?</span>
        <a class="button" id="yesButton">Yes</a> /
        <a class="button" id="noButton">No</a>
      </div>
      <div id="feedback-submitted-container">
        <span class="side-title">Thank you for your feedback!</span>
      </div>
    </div>
    <div id="feedback-window-container">
      <div id="feedback-form-window" style="background-color: white;">
        <h1 class="feedback-extw__title">Give article feedback</h1>
        <p>Tell us how we can improve this article</p>
        <span id="feedback-form-popup-container"></span>
        <form id="feedback-form">
          <div id="feedback-checkbox-area">
            <input id="hidden-sheet-id" type="hidden" value="14zzclhdh7dMLpg0iq4-2hweCdEiuxxqP3tHdr42-_Cs">
            <label>
              <input type="checkbox" data-bind="checked: outdatedSample" /> Code samples are inaccurate / outdated.
            </label>
            <span class="required-field" data-bind="visible: outdatedSample"></span>
            <textarea id="feedback-code-sample-text-input" placeholder="Please, specify more details ..." class="feedback-extw__textarea"
              data-bind="visible: outdatedSample, value: inaccurateOutdatedCodeSamplesText">
          </textarea>
            <label>
              <input type="checkbox" data-bind="checked: otherMoreInformation" /> I expected to find other / more information.
            </label>
            <span class="required-field" data-bind="visible: otherMoreInformation"></span>
            <textarea id="feedback-more-information-text-input" class="feedback-extw__textarea" placeholder="Please, specify what information can be added ..."
              data-bind="visible: otherMoreInformation, value: otherMoreInformationText">
          </textarea>
            <label>
              <input type="checkbox" data-bind="checked: textErrors" /> There are typos / broken links / broken page elements.
            </label>
            <span class="required-field" data-bind="visible: textErrors"></span>
            <textarea id="feedback-text-errors-text-input" class="feedback-extw__textarea" placeholder="Please, specify what needs to be fixed ..."
              data-bind="visible: textErrors, value: typosLinksElementsText">
          </textarea>
            <label>
              <input type="checkbox" data-bind="checked: inaccurateContent" /> Content is inaccurate / outdated.
            </label>
            <span class="required-field" data-bind="visible: inaccurateContent"></span>
            <textarea id="feedback-inaccurate-content-text-input" class="feedback-extw__textarea" placeholder="Please, specify which conent ..."
              data-bind="visible: inaccurateContent, value: inaccurateOutdatedContentText"></textarea>
            <label>
              <input type="checkbox" data-bind="checked: otherFeedback" /> Other
            </label>
            <span class="required-field" data-bind="visible: otherFeedback"></span>
            <textarea id="feedback-other-text-input" placeholder="Please, enter more details or not listed feedback ..." class="feedback-extw__textarea"
              data-bind="visible: otherFeedback, value: textFeedback">
          </textarea>
            <input id="feedback-email-input" type="email" placeholder="email (optional)" data-email-msg="Email format is not valid."
              class="feedback-extw__input input" data-bind="value: email" />
          </div>
        </form>
        <div class="feedback-extw__foot">
          <button id="form-submit-button" class="feedback-extw__button button button--action">Send feedback</button>
          <button id="form-close-button" class="feedback-extw__button button">Cancel</button>
        </div>
      </div>
    </div>
    <a id="close-button" class="button">
      <img src="/images/close-btn.svg" alt="close" />
    </a>
  </div>
  <div id="feedback-section-dummy">Dummy</div>
</div>
    <footer>
    <p>Copyright &copy; 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.</p>
</footer>

</div>
    </body>
</html>

